package com.alex.wechat.component.account.controller;

import java.io.IOException;
import java.net.URI;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolation;
import javax.validation.Validator;

import org.apache.log4j.Logger;
import org.jeecgframework.core.beanvalidator.BeanValidators;
import org.jeecgframework.core.common.controller.BaseController;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery;
import org.jeecgframework.core.common.model.json.AjaxJson;
import org.jeecgframework.core.common.model.json.DataGrid;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.ExceptionUtil;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.ResourceUtil;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.entity.vo.NormalExcelConstants;
import org.jeecgframework.tag.core.easyui.TagUtil;
import org.jeecgframework.web.system.pojo.base.TSDepart;
import org.jeecgframework.web.system.pojo.base.TSUser;
import org.jeecgframework.web.system.service.SystemService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.ResponseStatus;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.util.UriComponentsBuilder;

import com.alex.wechat.app.account.entity.WxAppAccountEntity;
import com.alex.wechat.app.account.service.WxAppAccountServiceI;
import com.alex.wechat.component.account.entity.WxComponentAccountEntity;
import com.alex.wechat.component.account.service.WxComponentAccountServiceI;
import com.alex.wechat.component.config.WxComponentContext;

import me.chanjar.weixin.component.api.WxCompService;
import me.chanjar.weixin.component.bean.author.WxApiQueryAuthResult;

/**
 * @Title: Controller
 * @Description: 第三方平台账户
 * @author onlineGenerator
 * @date 2017-05-25 12:00:31
 * @version V1.0
 *
 */
@Controller
@RequestMapping("/wxComponentAccountController")
public class WxComponentAccountController extends BaseController {
  /**
   * Logger for this class
   */
  private static final Logger logger = Logger.getLogger(WxComponentAccountController.class);

  @Autowired
  private WxComponentAccountServiceI wxComponentAccountService;
  @Autowired
  private SystemService systemService;
  @Autowired
  private Validator validator;
  @Autowired
  private WxCompService componentService;
  @Autowired
  private WxAppAccountServiceI wxAppAccountService;

  /**
   * 显示第三方平台账户的授权页面
   * 
   * @param appId
   *          第三方开放平台账户AppId
   * @return
   */
  @RequestMapping(params = "authorPage")
  public ModelAndView authorPage(@RequestParam("appId") String appId) throws Exception {
    final String original = WxComponentContext.getAppId();
    String authPageUrl = null;
    try {
      WxComponentContext.setAppId(appId);
      authPageUrl = componentService.getAuthorService().getComponentLoginPageUrl();
    } finally {
      // 回滚当前第三方开放平台账户，防止切换当前登录人员的账户
      WxComponentContext.setAppId(original);
    }
    return new ModelAndView("redirect:" + authPageUrl);
  }

  /**
   * 第三方平台账户列表 页面跳转
   * 
   * @return
   */
  @RequestMapping(params = "list")
  public ModelAndView list(HttpServletRequest request) {
    return new ModelAndView("com/gomore/wechat/component/account/wxComponentAccountList");
  }

  /**
   * easyui AJAX请求数据
   * 
   * @param request
   * @param response
   * @param dataGrid
   * @param user
   */

  @RequestMapping(params = "datagrid")
  public void datagrid(WxComponentAccountEntity wxComponentAccount, HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WxComponentAccountEntity.class, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, wxComponentAccount,
        request.getParameterMap());
    try {
      // 自定义追加查询条件
    } catch (Exception e) {
      throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.wxComponentAccountService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }

  /**
   * 删除第三方平台账户
   * 
   * @return
   */
  @RequestMapping(params = "doDel")
  @ResponseBody
  public AjaxJson doDel(WxComponentAccountEntity wxComponentAccount, HttpServletRequest request) {
    String message = null;
    AjaxJson j = new AjaxJson();
    wxComponentAccount = systemService.getEntity(WxComponentAccountEntity.class,
        wxComponentAccount.getId());
    message = "第三方平台账户删除成功";
    try {
      wxComponentAccountService.delete(wxComponentAccount);
      systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
    } catch (Exception e) {
      e.printStackTrace();
      message = "第三方平台账户删除失败";
      throw new BusinessException(e.getMessage());
    }
    j.setMsg(message);
    return j;
  }

  /**
   * 批量删除第三方平台账户
   * 
   * @return
   */
  @RequestMapping(params = "doBatchDel")
  @ResponseBody
  public AjaxJson doBatchDel(String ids, HttpServletRequest request) {
    String message = null;
    AjaxJson j = new AjaxJson();
    message = "第三方平台账户删除成功";
    try {
      for (String id : ids.split(",")) {
        WxComponentAccountEntity wxComponentAccount = systemService
            .getEntity(WxComponentAccountEntity.class, id);
        wxComponentAccountService.delete(wxComponentAccount);
        systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
      }
    } catch (Exception e) {
      e.printStackTrace();
      message = "第三方平台账户删除失败";
      throw new BusinessException(e.getMessage());
    }
    j.setMsg(message);
    return j;
  }

  /**
   * 添加第三方平台账户
   * 
   * @param ids
   * @return
   */
  @RequestMapping(params = "doAdd")
  @ResponseBody
  public AjaxJson doAdd(WxComponentAccountEntity wxComponentAccount, HttpServletRequest request) {
    String message = null;
    AjaxJson j = new AjaxJson();
    message = "第三方平台账户添加成功";
    try {
      wxComponentAccountService.save(wxComponentAccount);
      systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
    } catch (Exception e) {
      e.printStackTrace();
      message = "第三方平台账户添加失败";
      throw new BusinessException(e.getMessage());
    }
    j.setMsg(message);
    return j;
  }

  /**
   * 更新第三方平台账户
   * 
   * @param ids
   * @return
   */
  @RequestMapping(params = "doUpdate")
  @ResponseBody
  public AjaxJson doUpdate(WxComponentAccountEntity wxComponentAccount,
      HttpServletRequest request) {
    String message = null;
    AjaxJson j = new AjaxJson();
    message = "第三方平台账户更新成功";
    WxComponentAccountEntity t = wxComponentAccountService.get(WxComponentAccountEntity.class,
        wxComponentAccount.getId());
    try {
      MyBeanUtils.copyBeanNotNull2Bean(wxComponentAccount, t);
      wxComponentAccountService.saveOrUpdate(t);
      systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
    } catch (Exception e) {
      e.printStackTrace();
      message = "第三方平台账户更新失败";
      throw new BusinessException(e.getMessage());
    }
    j.setMsg(message);
    return j;
  }

  /**
   * 第三方平台账户新增页面跳转
   * 
   * @return
   */
  @RequestMapping(params = "goAdd")
  public ModelAndView goAdd(WxComponentAccountEntity wxComponentAccount, HttpServletRequest req) {
    if (StringUtil.isNotEmpty(wxComponentAccount.getId())) {
      wxComponentAccount = wxComponentAccountService.getEntity(WxComponentAccountEntity.class,
          wxComponentAccount.getId());
      req.setAttribute("wxComponentAccountPage", wxComponentAccount);
    }
    return new ModelAndView("com/gomore/wechat/component/account/wxComponentAccount-add");
  }

  /**
   * 第三方平台账户编辑页面跳转
   * 
   * @return
   */
  @RequestMapping(params = "goUpdate")
  public ModelAndView goUpdate(WxComponentAccountEntity wxComponentAccount,
      HttpServletRequest req) {
    if (StringUtil.isNotEmpty(wxComponentAccount.getId())) {
      wxComponentAccount = wxComponentAccountService.getEntity(WxComponentAccountEntity.class,
          wxComponentAccount.getId());
      req.setAttribute("wxComponentAccountPage", wxComponentAccount);
    }
    return new ModelAndView("com/gomore/wechat/component/account/wxComponentAccount-update");
  }

  /**
   * 导入功能跳转
   * 
   * @return
   */
  @RequestMapping(params = "upload")
  public ModelAndView upload(HttpServletRequest req) {
    req.setAttribute("controller_name", "wxComponentAccountController");
    return new ModelAndView("common/upload/pub_excel_upload");
  }

  /**
   * 导出excel
   * 
   * @param request
   * @param response
   */
  @RequestMapping(params = "exportXls")
  public String exportXls(WxComponentAccountEntity wxComponentAccount, HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid, ModelMap modelMap) {
    CriteriaQuery cq = new CriteriaQuery(WxComponentAccountEntity.class, dataGrid);
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, wxComponentAccount,
        request.getParameterMap());
    List<WxComponentAccountEntity> wxComponentAccounts = this.wxComponentAccountService
        .getListByCriteriaQuery(cq, false);
    modelMap.put(NormalExcelConstants.FILE_NAME, "第三方平台账户");
    modelMap.put(NormalExcelConstants.CLASS, WxComponentAccountEntity.class);
    modelMap.put(NormalExcelConstants.PARAMS, new ExportParams("第三方平台账户列表",
        "导出人:" + ResourceUtil.getSessionUserName().getRealName(), "导出信息"));
    modelMap.put(NormalExcelConstants.DATA_LIST, wxComponentAccounts);
    return NormalExcelConstants.JEECG_EXCEL_VIEW;
  }

  /**
   * 导出excel 使模板
   * 
   * @param request
   * @param response
   */
  @RequestMapping(params = "exportXlsByT")
  public String exportXlsByT(WxComponentAccountEntity wxComponentAccount,
      HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid,
      ModelMap modelMap) {
    modelMap.put(NormalExcelConstants.FILE_NAME, "第三方平台账户");
    modelMap.put(NormalExcelConstants.CLASS, WxComponentAccountEntity.class);
    modelMap.put(NormalExcelConstants.PARAMS, new ExportParams("第三方平台账户列表",
        "导出人:" + ResourceUtil.getSessionUserName().getRealName(), "导出信息"));
    modelMap.put(NormalExcelConstants.DATA_LIST, new ArrayList());
    return NormalExcelConstants.JEECG_EXCEL_VIEW;
  }

  @SuppressWarnings("unchecked")
  @RequestMapping(params = "importExcel", method = RequestMethod.POST)
  @ResponseBody
  public AjaxJson importExcel(HttpServletRequest request, HttpServletResponse response) {
    AjaxJson j = new AjaxJson();

    MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
    Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
    for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
      MultipartFile file = entity.getValue();// 获取上传文件对象
      ImportParams params = new ImportParams();
      params.setTitleRows(2);
      params.setHeadRows(1);
      params.setNeedSave(true);
      try {
        List<WxComponentAccountEntity> listWxComponentAccountEntitys = ExcelImportUtil
            .importExcel(file.getInputStream(), WxComponentAccountEntity.class, params);
        for (WxComponentAccountEntity wxComponentAccount : listWxComponentAccountEntitys) {
          wxComponentAccountService.save(wxComponentAccount);
        }
        j.setMsg("文件导入成功！");
      } catch (Exception e) {
        j.setMsg("文件导入失败！");
        logger.error(ExceptionUtil.getExceptionMessage(e));
      } finally {
        try {
          file.getInputStream().close();
        } catch (IOException e) {
          e.printStackTrace();
        }
      }
    }
    return j;
  }

  @RequestMapping(method = RequestMethod.GET)
  @ResponseBody
  public List<WxComponentAccountEntity> list() {
    List<WxComponentAccountEntity> listWxComponentAccounts = wxComponentAccountService
        .getList(WxComponentAccountEntity.class);
    return listWxComponentAccounts;
  }

  @RequestMapping(value = "/{id}", method = RequestMethod.GET)
  @ResponseBody
  public ResponseEntity<?> get(@PathVariable("id") String id) {
    WxComponentAccountEntity task = wxComponentAccountService.get(WxComponentAccountEntity.class,
        id);
    if (task == null) {
      return new ResponseEntity(HttpStatus.NOT_FOUND);
    }
    return new ResponseEntity(task, HttpStatus.OK);
  }

  @RequestMapping(method = RequestMethod.POST, consumes = MediaType.APPLICATION_JSON_VALUE)
  @ResponseBody
  public ResponseEntity<?> create(@RequestBody WxComponentAccountEntity wxComponentAccount,
      UriComponentsBuilder uriBuilder) {
    // 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
    Set<ConstraintViolation<WxComponentAccountEntity>> failures = validator
        .validate(wxComponentAccount);
    if (!failures.isEmpty()) {
      return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures),
          HttpStatus.BAD_REQUEST);
    }

    // 保存
    try {
      wxComponentAccountService.save(wxComponentAccount);
    } catch (Exception e) {
      e.printStackTrace();
      return new ResponseEntity(HttpStatus.NO_CONTENT);
    }
    // 按照Restful风格约定，创建指向新任务的url, 也可以直接返回id或对象.
    String id = wxComponentAccount.getId();
    URI uri = uriBuilder.path("/rest/wxComponentAccountController/" + id).build().toUri();
    HttpHeaders headers = new HttpHeaders();
    headers.setLocation(uri);

    return new ResponseEntity(headers, HttpStatus.CREATED);
  }

  @RequestMapping(value = "/{id}", method = RequestMethod.PUT,
      consumes = MediaType.APPLICATION_JSON_VALUE)
  public ResponseEntity<?> update(@RequestBody WxComponentAccountEntity wxComponentAccount) {
    // 调用JSR303 Bean Validator进行校验，如果出错返回含400错误码及json格式的错误信息.
    Set<ConstraintViolation<WxComponentAccountEntity>> failures = validator
        .validate(wxComponentAccount);
    if (!failures.isEmpty()) {
      return new ResponseEntity(BeanValidators.extractPropertyAndMessage(failures),
          HttpStatus.BAD_REQUEST);
    }

    // 保存
    try {
      wxComponentAccountService.saveOrUpdate(wxComponentAccount);
    } catch (Exception e) {
      e.printStackTrace();
      return new ResponseEntity(HttpStatus.NO_CONTENT);
    }

    // 按Restful约定，返回204状态码, 无内容. 也可以返回200状态码.
    return new ResponseEntity(HttpStatus.NO_CONTENT);
  }

  @RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
  @ResponseStatus(HttpStatus.NO_CONTENT)
  public void delete(@PathVariable("id") String id) {
    wxComponentAccountService.deleteEntityById(WxComponentAccountEntity.class, id);
  }

  /**
   * 设置为当前账户
   * 
   * @param ids
   * @return
   */
  @RequestMapping(params = "setCurrentAccount")
  @ResponseBody
  public AjaxJson setCurrentAcount(HttpServletRequest request) {

    String message = null;
    AjaxJson j = new AjaxJson();
    message = "设置成功";

    String id = request.getParameter("id");
    // 设置当前账户均为false
    String hql = "update " + WxComponentAccountEntity.class.getName()
        + " s set s.isCurrentAccount = ? ";
    systemService.executeHql(hql, false);

    WxComponentAccountEntity t = wxComponentAccountService.get(WxComponentAccountEntity.class, id);
    try {
      t.setIsCurrentAccount(true);
      wxComponentAccountService.saveOrUpdate(t);
      WxComponentContext.setAppId(t.getAppId());
      systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
    } catch (Exception e) {
      e.printStackTrace();
      message = "设置失败";
      throw new BusinessException(e.getMessage());
    }
    j.setMsg(message);

    return j;
  }

  /**
   * 选择小程序
   * 
   * @return
   */
  @RequestMapping(params = "selectApp")
  public ModelAndView appList(HttpServletRequest request) {
    return new ModelAndView("com/gomore/wechat/component/tester/selectApp");
  }

  /**
   * easyui AJAX请求数据
   * 
   * @param request
   * @param response
   * @param dataGrid
   * @param user
   */

  @RequestMapping(params = "datagridApp")
  public void datagridApp(WxComponentAccountEntity wxComponentAccount, HttpServletRequest request,
      HttpServletResponse response, DataGrid dataGrid) {
    CriteriaQuery cq = new CriteriaQuery(WxComponentAccountEntity.class, dataGrid);
    // 查询条件组装器
    org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, wxComponentAccount,
        request.getParameterMap());
    try {
      // 自定义追加查询条件
    } catch (Exception e) {
      throw new BusinessException(e.getMessage());
    }
    cq.add();
    this.wxComponentAccountService.getDataGridReturn(cq, true);
    TagUtil.datagrid(response, dataGrid);
  }

  /**
   * 同步域名
   * 
   * @return
   */
  @RequestMapping(params = "getUserAcct")
  @ResponseBody
  public AjaxJson getUserAcct(HttpServletRequest request) {
    String message = null;
    AjaxJson j = new AjaxJson();
    j.setSuccess(false);
    message = "获取用户失败";
    
    String authCode = request.getParameter("authCode");
    if (StringUtil.isEmpty(authCode)) {
      return j;
    }

    try {
      //获取授权方appId
      WxApiQueryAuthResult result = componentService.getAuthorService().queryAuthor(authCode);
      WxAppAccountEntity t = wxAppAccountService.getAccountByAppId(result.getAuthorizationInfo().getAuthorizerAppid());
      
      List<TSDepart> tsDeparts = systemService.findByProperty(TSDepart.class, "orgCode",t.getSysOrgCode());
      TSDepart tsDeaprt = null;
      if (tsDeparts != null && !tsDeparts.isEmpty()) {
        tsDeaprt = tsDeparts.get(0);
      }
      if (tsDeaprt != null) {
        List<TSUser> tsUsers = systemService.findByProperty(TSUser.class, "departid",
            tsDeaprt.getId());
        if (tsUsers != null && !tsUsers.isEmpty()) {
          j.setObj(tsUsers.get(0));
          j.setSuccess(true);
          message = "获取用户成功";
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
      message = "获取用户失败";
    }
    j.setMsg(message);
    return j;
  }

}
